package vip.xiaonuo.smzq.modular.psba.mapper;

import org.apache.ibatis.annotations.Param;
import org.apache.ibatis.annotations.Select;
import vip.xiaonuo.smzq.modular.psba.entity.PsbaGtBg;
import com.baomidou.mybatisplus.core.mapper.BaseMapper;
import org.apache.ibatis.annotations.Mapper;
import vip.xiaonuo.smzq.modular.psba.entity.vo.PsbaGtBgDetailVO;

import java.util.List;

/**
 * 评审备案报告情况 Mapper
 *
 * @author Kevin
 * @since 2024-05-15
 */
@Mapper
public interface PsbaGtBgMapper extends BaseMapper<PsbaGtBg> {

    /**
     * 评审备案报告详情
     *
     * @param psbabh
     * @return
     */
    @Select("select *\n" +
            "from psba_gt_bg t\n" +
            "where t.psbabh = #{psbabh}")
    List<PsbaGtBgDetailVO> getDetail(@Param("psbabh") String psbabh);
}
